/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : lzyky

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 23/01/2022 14:04:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token`  (
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `token` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'token',
  `expire_time` datetime(0) NULL DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES ('1471030131135893505', '1471030131135893505', '2022-01-24 00:40:36', '2022-01-23 12:40:36'), ('402896ca5f38db72015f38dc28640000', '402896ca5f38db72015f38dc28640000', '2022-01-24 00:41:55', '2022-01-23 12:41:55');
COMMIT;

-- ----------------------------
-- Table structure for t_conclude_application
-- ----------------------------
DROP TABLE IF EXISTS `t_conclude_application`;
CREATE TABLE `t_conclude_application`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '结题主键',
  `applicant` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '申请人',
  `applicate_time` datetime(0) NOT NULL COMMENT '申请时间',
  `back_information` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '驳回信息',
  `project_completion` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '结题说明',
  `project_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目id',
  `project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目名称',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '结题状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_conclude_application
-- ----------------------------
BEGIN;
INSERT INTO `t_conclude_application` VALUES ('1468423057887629314', '111', '2021-12-08 11:31:54', NULL, '结题把111', '1466202627625877506', '王者荣耀韩信如何做到无影步', '申报中');
COMMIT;

-- ----------------------------
-- Table structure for t_data_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `t_data_dictionary`;
CREATE TABLE `t_data_dictionary`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '明细值',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '明细名称',
  `type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '字典类型',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK1g4o8s9q2vpyp2tftoyd6prfp`(`type_id`) USING BTREE,
  CONSTRAINT `FK1g4o8s9q2vpyp2tftoyd6prfp` FOREIGN KEY (`type_id`) REFERENCES `t_data_dictionary_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_data_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `t_data_dictionary` VALUES ('1465618624195731457', 'LABORATORY', '实验室', '1465618086435627009'), ('1465618813073629185', 'KEY_LABORATORY', '重点实验室', '1465618086435627009'), ('1465618911081930753', 'RESEARCH_INSTITUTE', '研究所', '1465618086435627009'), ('1466304442497462274', 'ＮＥＷＳ', '新闻', '1466303949356363778'), ('1466304877165768706', 'DYNAMIC', '动态', '1466303949356363778'), ('1466305038935879681', 'ＭＥＳＳＡＧＥ', '通知', '1466303949356363778'), ('1468065756980834305', 'MENU', '菜单', '1468065567868055554'), ('1468065805567651841', 'BOTTON', '按钮', '1468065567868055554'), ('1471010732534480897', 'TEST_DETAIL1', '测试明细1', '1469184493446393857'), ('402896b55f6c17a6015f6c1df4360001', 'PROJECTLEVEL_COMMON', '普通项目', '402896b55f6c17a6015f6c1cc3b10000'), ('402896b55f6c17a6015f6c1e351c0002', 'PROJECTLEVEL_KEY', '重点项目', '402896b55f6c17a6015f6c1cc3b10000'), ('402896b55f6c17a6015f6c2900f40004', 'SCHOOL_OF_DIGITAL_MEDIA', '数字媒体学院', '402896b55f6c17a6015f6c2848610003'), ('402896b55f6c17a6015f6c2976df0005', 'SCHOOL_OF_DIGITAL_ECONOMICS', '数字经济学院', '402896b55f6c17a6015f6c2848610003'), ('402896b55f6c17a6015f6c2b3b740007', 'ACHIEVEMENTTYPE_PAPER', '论文', '402896b55f6c17a6015f6c2a812c0006'), ('402896b55f6c17a6015f6c2b88810008', 'ACHIEVEMENTTYPE_ENTITY', '实体', '402896b55f6c17a6015f6c2a812c0006'), ('402896b55f75207b015f757817030002', 'SUBJECT_MATH', '数学', '402896b55f75207b015f757566e80000'), ('402896b55f75207b015f757941b30003', 'SUBJECT_COMPUTER', '计算机', '402896b55f75207b015f757566e80000'), ('4028fbbd7d2bc16e017d2bc277560001', 'BIG_DATA_COLLAGE', '人工智能与大数据学院', '402896b55f6c17a6015f6c2848610003'), ('4028fbbd7d2bc16e017d2bc409dc0003', 'INTERNATIONAL_COLLEGE', '国际学院', '402896b55f6c17a6015f6c2848610003'), ('4028fbbd7d2bc16e017d2bcdbf890004', 'SCHOOL_OF_ELECTRONIC_AND_ELECTRICAL_ENGINEERING', '电子与电气工程学院', '402896b55f6c17a6015f6c2848610003');
COMMIT;

-- ----------------------------
-- Table structure for t_data_dictionary_type
-- ----------------------------
DROP TABLE IF EXISTS `t_data_dictionary_type`;
CREATE TABLE `t_data_dictionary_type`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类别代码',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类别名称',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `UK_db5rt211jr732oscxmxjt1vu7`(`code`) USING BTREE,
  UNIQUE INDEX `UK_q0331knscty81fr5rq0s6bl1t`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_data_dictionary_type
-- ----------------------------
BEGIN;
INSERT INTO `t_data_dictionary_type` VALUES ('1465618086435627009', 'ORGANIZATION_TYPE', '机构类型'), ('1466303949356363778', 'NOTICE_TYPE', '公告类型'), ('1468065567868055554', 'PERMISSION_TYPE', '权限类型'), ('1469184493446393857', 'CATEGORY_DEMO1', '数据字典类型测试1'), ('402896b55f6c17a6015f6c1cc3b10000', 'PROJECTLEVEL', '项目等级'), ('402896b55f6c17a6015f6c2848610003', 'COLLEGE', '学院'), ('402896b55f6c17a6015f6c2a812c0006', 'ACHIEVEMENTTYPE', '项目结果类型'), ('402896b55f75207b015f757566e80000', 'SUBJECT', '学科');
COMMIT;

-- ----------------------------
-- Table structure for t_fund
-- ----------------------------
DROP TABLE IF EXISTS `t_fund`;
CREATE TABLE `t_fund`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `number` int(0) NOT NULL COMMENT '资金',
  `project_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目id',
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '资金名目',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKkrxr9g9y2oyst7x26ve7x59i5`(`project_id`) USING BTREE,
  CONSTRAINT `FKkrxr9g9y2oyst7x26ve7x59i5` FOREIGN KEY (`project_id`) REFERENCES `t_project` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_fund
-- ----------------------------
BEGIN;
INSERT INTO `t_fund` VALUES ('1465543384337903619', 1, '1465543384337903618', '工本费'), ('1466202627688792065', 1, '1466202627625877506', '赞助费'), ('40282a817d50e7b7017d50f991880001', 1, '40282a817d50e7b7017d50f991600000', '教室购买'), ('40282a817d50e7b7017d50f991880002', 5, '40282a817d50e7b7017d50f991600000', '计算机购买'), ('4028fb9f7d6b23a3017d6b2b33f70015', 1, '4028fb9f7d6b23a3017d6b2b33bc0014', '无'), ('4028fb9f7d6b23a3017d6b2b33f70016', 1111, '4028fb9f7d6b23a3017d6b2b33bc0014', '111');
COMMIT;

-- ----------------------------
-- Table structure for t_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_notice`;
CREATE TABLE `t_notice`  (
  `id` bigint(0) NOT NULL COMMENT '公告主键',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
  `information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容主体',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '发布时间',
  `created_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发布者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `updated_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改者',
  `weight` double NULL DEFAULT NULL COMMENT '权重',
  `notice_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '通知类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_notice
-- ----------------------------
BEGIN;
INSERT INTO `t_notice` VALUES (1212443543453234252, 'Vue项目Vite配置代理解决跨域问题', 'Vite基于浏览器原生 ES imports 的开发服务器。利用浏览器去解析 imports，在服务器端按需编译返回，完全跳过了打包这个概念，服务器随起随用。既然这么好，那就赶紧体验下。', '2021-12-02 13:27:31', 'admin', '2021-12-02 13:27:38', 'admin', NULL, '动态'), (1465618086435627009, '科研信息管理系统竣工！！！', '欢迎大家使用', '2021-12-02 13:16:48', 'admin', '2021-12-02 13:16:55', 'admin', NULL, '新闻'), (1467748982745755650, '震惊！屹达驾校C1学费涨价到3000', '震惊!泸州职业技术学院的屹达驾校C1手动档的学费从原来的2300涨价到3000.', '2021-12-06 15:21:22', 'admin', '2021-12-06 15:20:57', 'admin', NULL, '新闻'), (1467753574187515906, '动态说明', '动态说明内容主体', '2021-12-06 15:11:36', 'admin', '2021-12-06 15:23:55', 'admin', NULL, '动态'), (1468568243567378434, '我国学者揭示早期宇宙星际间重元素起源之谜', '9月27日，国际知名天文期刊《自然—天文》（Nature Astronomy）发表了清华大学天文系教授蔡峥课题组的研究结果。课题组通过观测发现，大质量星体的反馈作用对于早期宇宙重元素起源的影响力，要比之前普遍认知的要大得多。\n\n　　在接受《中国科学报》采访时，蔡峥介绍说，在宇宙中，绝大部分物质不在星系里，而在星系之间。这部分弥散在星系之间广袤空间里的物质被称为星系际介质。\n\n　　在宇宙大爆炸初期，宇宙中只存在大量的氢、氦和少量的锂，没有更重的元素（如碳，氮，氧等）。但是天文学家们从距离大爆炸仅10亿年的宇宙中，利用类星体光谱，确认了星系际介质中已经存在了较重的元素。\n\n　　“这些早期宇宙中的重元素究竟从何而来，它们又是如何到达星际介质中的？这一问题直到今天依然是观测宇宙学的一个关键性问题。”蔡峥说，今年4月，《科学》联合上海交通大学发布了人类目前125个比较难解的科学问题，早期宇宙中重元素的起源问题便位列其中。\n', '2021-12-08 21:08:48', 'admin', '2021-12-08 21:09:28', 'admin', NULL, '新闻'), (1468569098861461505, '服务API版本控制设计与实践', '笔者曾负责vivo应用商店服务器开发，有幸见证应用商店从百万日活到几千万日活的发展历程。应用商店客户端经历了大大小小上百个版本迭代后，服务端也在架构上完成了单体到服务集群、微服务升级。\n\n\n\n下面主要聊一聊在业务快速发展过程中，产品不断迭代，服务端在兼容不同版本客户端的API遇到的问题的一些经验和心得。一方面让团队内童鞋对已有的一些设计思想有一个更彻底的理解，另一方面也是希望能引起一些遇到类似场景同行的共鸣，提供解决思路。', '2021-12-08 21:12:12', 'admin', '2021-12-08 21:12:45', 'admin', NULL, '动态'), (1468569784101650433, '2021年11月下旬流通领域重要生产资料市场价格变动情况', '\n　　据对全国流通领域9大类50种重要生产资料市场价格的监测显示，2021年11月下旬与11月中旬相比，16种产品价格上涨，29种下降，5种持平。', '2021-12-08 21:14:55', 'admin', '2021-12-08 21:15:20', 'admin', NULL, '通知'), (1468842220147802114, '1', '<p><strong style=\"background-color: rgb(230, 0, 0);\"><em>11111</em></strong></p>', '2021-12-09 15:17:29', 'admin', '2021-12-09 15:26:43', 'admin', NULL, NULL), (1468843296464928769, '11', '<p><u style=\"color: rgb(230, 0, 0);\">1212121</u></p>', '2021-12-09 15:21:46', 'admin', '2021-12-09 15:21:46', 'admin', NULL, ''), (1474039412499955714, '112', '<p>111</p>', '2021-12-23 23:29:16', 'admin', '2021-12-23 23:33:33', 'admin', NULL, '动态'), (6455618086435627013, 'TIOBE 10 月榜单：Python 夺冠，Java 和 C 长期霸权结束', '<p>在进行了几个月的追逐之后，Python 成功在 10 月份超越了霸榜已久的 C 语言，夺得了 TIOBE 编程语言排行榜首的位置。TIOBE CEO Paul Jansen 评价称，“20 多年来，我们第一次有了一个新的领导者：Python 编程语言。Java 和 C 的长期霸权地位已经结束。Python，起初是一种简单的脚本语言，作为 Perl 的替代品，现在已经变得成熟。它的易学性、大量的库以及在各种领域的广泛使用，使它成为当今最流行的编程语言。”</p>', '2021-12-02 13:26:17', 'admin', '2021-12-09 15:27:34', 'admin', NULL, '新闻');
COMMIT;

-- ----------------------------
-- Table structure for t_organization
-- ----------------------------
DROP TABLE IF EXISTS `t_organization`;
CREATE TABLE `t_organization`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',
  `organization_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '机构名称',
  `organization_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '机构类型',
  `principal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
  `principal_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人id（从用户表中找）',
  `affiliated_collage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属院系',
  `establishment_time` date NULL DEFAULT NULL COMMENT '成立时间',
  `member_json` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '机构成员',
  `research_achievements_json` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '科研成果',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '机构电话',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_organization
-- ----------------------------
BEGIN;
INSERT INTO `t_organization` VALUES ('1465959874054680577', '泸职院科研处', '重点实验室', '彭某某', '', '人工智能与大数据学院', '2021-12-01', '[{\"memberName\":\"彭凤凯\",\"phone\":\"19802871486\"}]', '[{\"achievementType\":\"论文\",\"name\":\"无\",\"project\":\"毕业答辩\",\"subject\":\"数学\"}]', '19138582014'), ('1466023294628073474', '成都天府三街实验室', '实验室', '李四', NULL, '数字经济学院', '2019-08-31', '[{\"memberName\":\"李维\",\"phone\":\"13547211289\"}]', '[{\"achievementType\":\"论文\",\"name\":\"如何爱上科学\",\"project\":\"毕业答辩\",\"subject\":\"数学\"}]', '028-2001041'), ('1466201334194798593', '泸州市龙马潭区王者荣耀研究所', '研究所', '王某某', NULL, '国际学院', '2021-12-02', '[{\"memberName\":\"李广\",\"phone\":\"18982479858\"}]', '[{\"achievementType\":\"实体\",\"name\":\"关于提高王者荣耀韩信的操作水平\",\"project\":\"王者荣耀韩信如何做到无影步\",\"subject\":\"计算机\"}]', '19802871486'), ('1474037882656931842', '人工智能与大数据学院科研处', '重点实验室', '张三三', NULL, '人工智能与大数据学院', '2021-12-22', '[{\"memberName\":\"\",\"phone\":\"\"}]', '[{\"subject\":\"\"}]', '028-123123');
COMMIT;

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限编码',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限名',
  `parent_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '父id',
  `sort` int(0) NULL DEFAULT NULL COMMENT '排序',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '类型',
  `is_leaf` int(0) NOT NULL COMMENT '是否为叶子节点（0：否，1：是）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKjpo0wq99a03xl6oxm1gcwmbol`(`parent_id`) USING BTREE,
  CONSTRAINT `FKjpo0wq99a03xl6oxm1gcwmbol` FOREIGN KEY (`parent_id`) REFERENCES `t_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_permission` VALUES ('1465625043305373698', 'account:organization:*', '机构管理', NULL, NULL, 'MENU', 0), ('1465625207164248066', 'account:organization:list', '机构列表', '1465625043305373698', NULL, 'BUTTON', 1), ('1466250736930287617', 'account:organization:add', '添加机构', '1465625043305373698', NULL, 'BUTTON', 1), ('1466250811962191874', 'account:organization:update', '编辑机构', '1465625043305373698', NULL, 'BUTTON', 1), ('1466250937950695425', 'account:organization:detail', '查看详情', '1465625043305373698', NULL, 'BUTTON', 1), ('1466251006531760130', 'account:organization:delete', '机构取消', '1465625043305373698', NULL, 'BUTTON', 1), ('1466299060987326466', 'account:notice:*', '公告管理', NULL, NULL, 'MENU', 0), ('1466299430757167105', 'account:notice:list', '公告列表', '1466299060987326466', NULL, 'BUTTON', 1), ('1466300525596340225', 'account:notice:add', '添加公告', '1466299060987326466', NULL, 'BUTTON', 1), ('1466300869688651777', 'account:notice:update', '编辑公告', '1466299060987326466', NULL, 'BUTTON', 1), ('1466300983287181314', 'account:notice:detail', '查看公告', '1466299060987326466', NULL, 'BUTTON', 1), ('1466301116028514306', 'account:notice:delete', '删除公告', '1466299060987326466', NULL, 'BUTTON', 1), ('1468084226153902081', 'account:people:*', '人员管理', NULL, NULL, 'MENU', 0), ('1470363262422732802', 'DEMO_TEST', '测试权限', NULL, NULL, 'MENU', 0), ('2c93d0815fd2dff8015fd2e567140000', 'account:project:*', '项目管理', NULL, NULL, 'MENU', 0), ('2c93d0815fd2dff8015fd2e5d64a0001', 'account:project:list', '项目列表', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2dff8015fd2e6830c0002', 'account:project:add', '项目添加', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2e800015fd2e86ac10000', 'account:project:delete', '项目删除', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2e800015fd2e8dbec0001', 'account:project:update', '项目编辑', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2e800015fd2e9e5850002', 'account:project:detail', '项目详情', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2e800015fd2ea2f730003', 'account:project:application', '项目申报', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd2e800015fd2eac2ba0004', 'account:project:conclude', '项目结题', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd3158d260000', 'account:project:updateApplication', '项目变更', '2c93d0815fd2dff8015fd2e567140000', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd318c55a0001', 'account:conclude:*', '结题管理', '2c93d0815fd2dff8015fd2e567140000', NULL, 'MENU', 0), ('2c93d0815fd312d3015fd31d8ab10002', 'account:conclude:list', '结题列表', '2c93d0815fd312d3015fd318c55a0001', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd3228bcc0003', 'account:conclude:detail', '申请详情', '2c93d0815fd312d3015fd318c55a0001', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd322c2df0004', 'account:conclude:pass', '申请通过', '2c93d0815fd312d3015fd318c55a0001', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd323341c0005', 'account:conclude:notpass', '申请驳回', '2c93d0815fd312d3015fd318c55a0001', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd32d2bf50006', 'account:application:*', '申报管理', '2c93d0815fd2dff8015fd2e567140000', NULL, 'MENU', 0), ('2c93d0815fd312d3015fd32dbe1d0007', 'account:application:list', '申报列表', '2c93d0815fd312d3015fd32d2bf50006', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd32ded5b0008', 'account:application:notpass', '申报驳回', '2c93d0815fd312d3015fd32d2bf50006', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd32e128a0009', 'account:application:pass', '申报通过', '2c93d0815fd312d3015fd32d2bf50006', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd32e3fbb000a', 'account:application:detail', '申报详情', '2c93d0815fd312d3015fd32d2bf50006', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd332d51c000b', 'account:projectUpdate:*', '变更管理', '2c93d0815fd2dff8015fd2e567140000', NULL, 'MENU', 0), ('2c93d0815fd312d3015fd3330443000c', 'account:projectUpdate:list', '变更列表', '2c93d0815fd312d3015fd332d51c000b', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd33334e5000d', 'account:projectUpdate:detail', '变更详情', '2c93d0815fd312d3015fd332d51c000b', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd3335c12000e', 'account:projectUpdate:pass', '变更通过', '2c93d0815fd312d3015fd332d51c000b', NULL, 'BUTTON', 1), ('2c93d0815fd312d3015fd33397f4000f', 'account:projectUpdate:notpass', '变更驳回', '2c93d0815fd312d3015fd332d51c000b', NULL, 'BUTTON', 1), ('4028862b5d987476015d987949820000', 'system:dataDictionary:*', '数据字典', NULL, NULL, 'MENU', 0), ('ff8080815d4e9212015d4e9714cd0003', 'account:user:*', '用户管理', '1468084226153902081', NULL, 'MENU', 0), ('ff8080815d4e9212015d4e9796070004', 'account:user:add', '添加用户', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fc0e2015d4fd29cf00000', 'account:user:update', '修改用户', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fc0e2015d4fd2f59e0001', 'account:user:delete', '删除用户', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fd7244a0001', 'account:user:list', '用户列表', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fd7d96b0002', 'account:user:password', '修改密码', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fd919fd0004', 'account:user:status', '禁用启用用户', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fd9931d0005', 'account:user:permission', '分配权限', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fda70b50006', 'account:user:role', '分配角色', 'ff8080815d4e9212015d4e9714cd0003', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fdf6b450008', 'account:role:*', '角色管理', '1468084226153902081', NULL, 'MENU', 0), ('ff8080815d4fd4d9015d4fdf99570009', 'account:role:add', '添加角色', 'ff8080815d4fd4d9015d4fdf6b450008', NULL, 'BUTTON', 1), ('ff8080815d4fd4d9015d4fe03177000b', 'account:role:update', '修改角色', 'ff8080815d4fd4d9015d4fdf6b450008', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d511fa2410000', 'account:role:delete', '删除角色', 'ff8080815d4fd4d9015d4fdf6b450008', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d512057050001', 'account:role:list', '角色列表', 'ff8080815d4fd4d9015d4fdf6b450008', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d5120a1cd0002', 'account:permission:*', '权限管理', '1468084226153902081', NULL, 'MENU', 0), ('ff8080815d511dc6015d512160c10003', 'account:permission:list', '权限列表', 'ff8080815d511dc6015d5120a1cd0002', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d51218d630004', 'account:permission:add', '添加权限', 'ff8080815d511dc6015d5120a1cd0002', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d5121cbe00005', 'account:permission:update', '修改权限', 'ff8080815d511dc6015d5120a1cd0002', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d51220fd70006', 'account:permission:delete', '删除权限', 'ff8080815d511dc6015d5120a1cd0002', NULL, 'BUTTON', 1), ('ff8080815d511dc6015d51231c4a0007', 'account:role:permission', '角色分配权限', 'ff8080815d4fd4d9015d4fdf6b450008', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e702a7afd0000', 'system:dictType:*', '类型', '4028862b5d987476015d987949820000', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e702ac7790001', 'system:dictType:list', '列表', 'ff8080815e6fecbf015e702a7afd0000', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e702d3e080002', 'system:dictType:add', '添加', 'ff8080815e6fecbf015e702a7afd0000', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e702d84220003', 'system:dictType:update', '更新', 'ff8080815e6fecbf015e702a7afd0000', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e702dabbd0004', 'system:dictType:delete', '删除', 'ff8080815e6fecbf015e702a7afd0000', NULL, 'BUTTON', 1), ('ff8080815e6fecbf015e703174990005', 'system:dictDetail:*', '明细', '4028862b5d987476015d987949820000', NULL, 'BUTTON', 1), ('ff8080815e703b3a015e703c3d310000', 'system:dictDetail:add', '添加', 'ff8080815e6fecbf015e703174990005', NULL, 'BUTTON', 1), ('ff8080815e703b3a015e703c823b0001', 'system:dictDetail:delete', '删除', 'ff8080815e6fecbf015e703174990005', NULL, 'BUTTON', 1), ('ff8080815e703b3a015e703cad8b0002', 'system:dictDetail:update', '修改', 'ff8080815e6fecbf015e703174990005', NULL, 'BUTTON', 1), ('ff8080815e703b3a015e703cf71b0003', 'system:dictDetail:list', '列表', 'ff8080815e6fecbf015e703174990005', NULL, 'BUTTON', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_project
-- ----------------------------
DROP TABLE IF EXISTS `t_project`;
CREATE TABLE `t_project`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `achievement_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '结果类型',
  `begin_time` datetime(0) NOT NULL COMMENT '开始时间',
  `can_application` bit(1) NULL DEFAULT NULL COMMENT '能否申请',
  `can_conclude` bit(1) NULL DEFAULT NULL COMMENT '能否结题',
  `can_update` bit(1) NULL DEFAULT NULL COMMENT '能否变更',
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '所属学院',
  `created_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '创建者',
  `economic_analysis` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '效益分析',
  `existing_conditions` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '现有条件',
  `expected_result` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '预期结果',
  `level` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目级别',
  `member_jsons` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '成员（json形式）',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目名称',
  `purpose` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '立项目的',
  `status` int(0) NOT NULL COMMENT '状态',
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '学科',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '负责人',
  `viable_analysis` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '方案分析',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_project
-- ----------------------------
BEGIN;
INSERT INTO `t_project` VALUES ('1465543384337903618', '实体', '2021-11-30 12:49:06', b'1', b'1', b'1', '人工智能与大数据学院', 'admin', '可行', '同学、师资、宣讲人', '全专业人员比往年提前就业', '重点项目', '[{\"memberName\":\"苏义军\",\"phone\":\"19138582014\"}]', '实习动员大会', '推进我院应届生同学就业的速度', 4, '计算机', '111', '可行'), ('1466202627625877506', '论文', '2021-12-02 08:28:42', b'1', b'1', b'1', '国际学院', 'admin', '可以拉开高阶玩家与普通玩家的区别', '有韩信的账号、手机、网络通畅', '王者荣耀韩信需要一技能第二段才能触发', '普通项目', '[{\"memberName\":\"李广\",\"phone\":\"18982479858\"}]', '王者荣耀韩信如何做到无影步', '研究高阶打法', 7, '计算机', '李广', '可行'), ('1470261808056045570', '实体', '2021-12-13 13:18:26', b'1', b'1', b'1', '电子与电气工程学院', '111', '1', '1', '1', '普通项目', '[{\"memberName\":\"\",\"phone\":\"\"}]', '第一次测试项目', '1', 2, '数学', '111', '1'), ('1474041668746162178', '论文', '2021-12-23 23:38:15', b'1', b'1', b'1', '人工智能与大数据学院', '111', '1', '11', '11', '重点项目', '[{\"memberName\":\"\",\"phone\":\"\"}]', '项目答辩测试项目', '11', 0, '数学', '111', '1'), ('1474043305174839298', '实体', '2021-12-23 23:44:45', b'1', b'1', b'1', '数字经济学院', '111', '1', '1', '1', '重点项目', '[{\"memberName\":\"\",\"phone\":\"\"}]', '33', '1', 8, '计算机', '111', '1'), ('40282a817d50e7b7017d50f991600000', '实体', '2021-11-24 16:04:33', b'1', b'1', b'1', '人工智能与大数据学院', 'admin', '为社会输送人才', '人员', '很哈皮', '重点项目', '[{\"memberName\":\"彭凤凯\",\"phone\":\"19802871486\"},{\"memberName\":\"李维\",\"phone\":\"19138582014\"}]', '毕业答辩', '为应届生设立的答辩项目', 0, '计算机', '彭凤凯', '暂无'), ('4028fb9f7d6b23a3017d6b2b33bc0014', '实体', '2021-11-29 18:08:53', b'1', b'1', b'1', '国际学院', 'admin', '1111111', '1111111', '啊啊啊', '普通项目', '[{\"memberName\":\"彭凤凯\",\"phone\":\"19802871486\"},{\"memberName\":\"李维\",\"phone\":\"19802871486\"}]', '每日一讲', '1111111', 4, '数学', '111', '1111111'), ('4028fb9f7d6b23a3017d6b2b33bc1014', '实体', '2021-11-29 18:08:53', b'1', b'1', b'1', '人工智能与大数据学院', 'admin', '1111111', '1111111', '啊啊啊', '重点项目', '[{\"memberName\":\"彭凤凯\",\"phone\":\"19802871486\"},{\"memberName\":\"李维\",\"phone\":\"19802871486\"}]', '周报信息统计', '1111111', 0, '数学', '111', '1111111');
COMMIT;

-- ----------------------------
-- Table structure for t_project_application
-- ----------------------------
DROP TABLE IF EXISTS `t_project_application`;
CREATE TABLE `t_project_application`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `applicant` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '申报人',
  `applicate_time` datetime(0) NOT NULL COMMENT '申报时间',
  `back_information` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '驳回信息',
  `project_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '申报说明',
  `project_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目id',
  `project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目名称',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '申报状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_project_application
-- ----------------------------
BEGIN;
INSERT INTO `t_project_application` VALUES ('1465969556206981121', 'admin', '2021-12-01 17:03:46', NULL, '申报', '1465543384337903618', '实习动员大会', '申报成功'), ('1468422921082015745', '李广', '2021-12-08 11:31:33', NULL, NULL, '1466202627625877506', '王者荣耀韩信如何做到无影步', '申报成功'), ('1474047013610684417', '111', '2021-12-23 23:59:29', NULL, NULL, '1474043305174839298', '33', '申报成功');
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '角色名',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `UK_bkpm7njy2ort1yoiddc7jg8gj`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('1471029270292746242', 'ROLE'), ('1468477192406237186', '公告管理员'), ('1468162917871599618', '教职工'), ('1468477381854560258', '数据字典管理员'), ('40282a817d548d3d017d548d99df0000', '机构管理员'), ('1470369884750598145', '测试角色'), ('40282a817d50e7b7017d50ffe8740006', '超级管理员'), ('1468477283707846657', '项目审核员');
COMMIT;

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `permission_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限id',
  `role_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_role_permission` VALUES ('06a14ea58aed40bea06809f3fac89cb2', '2c93d0815fd2e800015fd2ea2f730003', '2c93d0815fd36205015fd36b83640000'), ('07af31aaee77480082db794c6437b2c4', 'ff8080815d4fd4d9015d4fda70b50006', '2c93d0815fd36205015fd36b83640000'), ('0e9995ddaab24d849e8134373816d7eb', 'ff8080815d4fd4d9015d4fd7244a0001', '2c93d0815fd36205015fd36b83640000'), ('1032e82f29884a1782ceed26ceca763b', '2c93d0815fd312d3015fd32dbe1d0007', '2c93d0815fd36205015fd36b83640000'), ('14497429159d452b9173b4a466832035', '2c93d0815fd312d3015fd33334e5000d', '2c93d0815fd36205015fd36b83640000'), ('1463736544039813122', '1463494086873853953', '1463729334840848385'), ('1463736544039813123', '2c93d0815fd2dff8015fd2e567140000', '1463729334840848385'), ('1463736544039813124', '2c93d0815fd2dff8015fd2e5d64a0001', '1463729334840848385'), ('1463736544039813125', '2c93d0815fd2dff8015fd2e6830c0002', '1463729334840848385'), ('1463736544039813126', '2c93d0815fd2e800015fd2e86ac10000', '1463729334840848385'), ('1463736544056590337', '2c93d0815fd2e800015fd2e8dbec0001', '1463729334840848385'), ('1463736544056590338', '2c93d0815fd2e800015fd2e9e5850002', '1463729334840848385'), ('1463736544056590339', '2c93d0815fd2e800015fd2ea2f730003', '1463729334840848385'), ('1463736544056590340', '2c93d0815fd2e800015fd2eac2ba0004', '1463729334840848385'), ('1463736544056590341', '2c93d0815fd312d3015fd3158d260000', '1463729334840848385'), ('1463736544056590342', '40282a817d4aaa31017d4aae56100000', '1463729334840848385'), ('1463866529348247554', '2c93d0815fd2dff8015fd2e5d64a0001', '1463866473278791682'), ('1463866529348247555', '2c93d0815fd2e800015fd2e9e5850002', '1463866473278791682'), ('1463866529348247556', '40282a817d4aaa31017d4aae56100000', '1463866473278791682'), ('1463866529348247557', '2c93d0815fd2e800015fd2eac2ba0004', '1463866473278791682'), ('1463866529415356418', '2c93d0815fd2e800015fd2e86ac10000', '1463866473278791682'), ('1463866529415356419', '2c93d0815fd2dff8015fd2e567140000', '1463866473278791682'), ('1463866529415356420', '2c93d0815fd2e800015fd2ea2f730003', '1463866473278791682'), ('1463866529415356421', '2c93d0815fd2dff8015fd2e6830c0002', '1463866473278791682'), ('1463866529415356422', '2c93d0815fd2e800015fd2e8dbec0001', '1463866473278791682'), ('1463866529415356423', '2c93d0815fd312d3015fd3158d260000', '1463866473278791682'), ('1468088077181476865', '2c93d0815fd312d3015fd31d8ab10002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476866', 'ff8080815e703b3a015e703c823b0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476867', '2c93d0815fd312d3015fd323341c0005', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476868', '2c93d0815fd312d3015fd318c55a0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476869', '1466251006531760130', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476870', 'ff8080815e6fecbf015e703174990005', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476871', 'ff8080815e703b3a015e703cf71b0003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476872', '1466300869688651777', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476873', '1466300983287181314', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476874', '1466299060987326466', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476875', 'ff8080815e6fecbf015e702dabbd0004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476876', '1466301116028514306', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476877', '2c93d0815fd312d3015fd33334e5000d', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476878', 'ff8080815e6fecbf015e702d3e080002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476879', '2c93d0815fd312d3015fd32e3fbb000a', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476880', '2c93d0815fd312d3015fd33397f4000f', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476881', '2c93d0815fd312d3015fd32dbe1d0007', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476882', '1466299430757167105', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476883', '2c93d0815fd2e800015fd2e9e5850002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476884', 'ff8080815e6fecbf015e702d84220003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476885', '2c93d0815fd2e800015fd2e86ac10000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476886', '2c93d0815fd2e800015fd2ea2f730003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476887', '2c93d0815fd312d3015fd322c2df0004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476888', '2c93d0815fd2dff8015fd2e5d64a0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476889', '2c93d0815fd312d3015fd332d51c000b', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476890', '1466250811962191874', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476891', '4028862b5d987476015d987949820000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476892', '1466250736930287617', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476893', '1466300525596340225', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476894', '2c93d0815fd312d3015fd32d2bf50006', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476895', '2c93d0815fd312d3015fd3330443000c', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476896', '40282a817d4aaa31017d4aae56100000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476897', '2c93d0815fd2e800015fd2eac2ba0004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476898', '2c93d0815fd2dff8015fd2e567140000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476899', 'ff8080815e703b3a015e703c3d310000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476900', '2c93d0815fd2dff8015fd2e6830c0002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476901', '2c93d0815fd312d3015fd3335c12000e', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476902', 'ff8080815e6fecbf015e702ac7790001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476903', '2c93d0815fd312d3015fd3158d260000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476904', '2c93d0815fd312d3015fd3228bcc0003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476905', '2c93d0815fd312d3015fd32e128a0009', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476906', '2c93d0815fd312d3015fd32ded5b0008', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476907', 'ff8080815e6fecbf015e702a7afd0000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476908', '1465625207164248066', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476909', '1465625043305373698', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476910', '1466250937950695425', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476911', 'ff8080815e703b3a015e703cad8b0002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476912', '2c93d0815fd2e800015fd2e8dbec0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476913', '1468084226153902081', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476914', 'ff8080815d4e9212015d4e9714cd0003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476915', 'ff8080815d4e9212015d4e9796070004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476916', 'ff8080815d4fc0e2015d4fd29cf00000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476917', 'ff8080815d4fc0e2015d4fd2f59e0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476918', 'ff8080815d4fd4d9015d4fd7244a0001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476919', 'ff8080815d4fd4d9015d4fd7d96b0002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476920', 'ff8080815d4fd4d9015d4fd919fd0004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476921', 'ff8080815d4fd4d9015d4fd9931d0005', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476922', 'ff8080815d4fd4d9015d4fda70b50006', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476923', 'ff8080815d4fd4d9015d4fdf6b450008', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476924', 'ff8080815d4fd4d9015d4fdf99570009', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476925', 'ff8080815d4fd4d9015d4fe03177000b', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476926', 'ff8080815d511dc6015d511fa2410000', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476927', 'ff8080815d511dc6015d512057050001', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476928', 'ff8080815d511dc6015d51231c4a0007', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476929', 'ff8080815d511dc6015d5120a1cd0002', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476930', 'ff8080815d511dc6015d512160c10003', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476931', 'ff8080815d511dc6015d51218d630004', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476932', 'ff8080815d511dc6015d5121cbe00005', '40282a817d50e7b7017d50ffe8740006'), ('1468088077181476933', 'ff8080815d511dc6015d51220fd70006', '40282a817d50e7b7017d50ffe8740006'), ('1468090287957172225', 'ff8080815d4e9212015d4e9796070004', '1468089424152846337'), ('1468090287957172226', 'ff8080815d4fc0e2015d4fd2f59e0001', '1468089424152846337'), ('1468090287957172227', 'ff8080815d4fc0e2015d4fd29cf00000', '1468089424152846337'), ('1468090287957172228', 'ff8080815d4fd4d9015d4fd7d96b0002', '1468089424152846337'), ('1468090287957172229', 'ff8080815d4fd4d9015d4fd7244a0001', '1468089424152846337'), ('1468476792588402689', '1465625043305373698', '40282a817d548d3d017d548d99df0000'), ('1468476792588402690', '1465625207164248066', '40282a817d548d3d017d548d99df0000'), ('1468476792588402691', '1466250736930287617', '40282a817d548d3d017d548d99df0000'), ('1468476792588402692', '1466250811962191874', '40282a817d548d3d017d548d99df0000'), ('1468476792588402693', '1466250937950695425', '40282a817d548d3d017d548d99df0000'), ('1468476792588402694', '1466251006531760130', '40282a817d548d3d017d548d99df0000'), ('1468476792588402695', '1466299060987326466', '40282a817d548d3d017d548d99df0000'), ('1468476792588402696', '1466299430757167105', '40282a817d548d3d017d548d99df0000'), ('1468477217689501697', '1466299060987326466', '1468477192406237186'), ('1468477217689501698', '1466299430757167105', '1468477192406237186'), ('1468477217689501699', '1466300525596340225', '1468477192406237186'), ('1468477217689501700', '1466300869688651777', '1468477192406237186'), ('1468477217689501701', '1466300983287181314', '1468477192406237186'), ('1468477217689501702', '1466301116028514306', '1468477192406237186'), ('1468477306914930689', '2c93d0815fd2dff8015fd2e567140000', '1468477283707846657'), ('1468477306914930690', '2c93d0815fd2dff8015fd2e5d64a0001', '1468477283707846657'), ('1468477306914930691', '2c93d0815fd2dff8015fd2e6830c0002', '1468477283707846657'), ('1468477306914930692', '2c93d0815fd2e800015fd2e86ac10000', '1468477283707846657'), ('1468477306914930693', '2c93d0815fd2e800015fd2e8dbec0001', '1468477283707846657'), ('1468477306914930694', '2c93d0815fd2e800015fd2e9e5850002', '1468477283707846657'), ('1468477306914930695', '2c93d0815fd2e800015fd2ea2f730003', '1468477283707846657'), ('1468477306914930696', '2c93d0815fd2e800015fd2eac2ba0004', '1468477283707846657'), ('1468477306914930697', '2c93d0815fd312d3015fd3158d260000', '1468477283707846657'), ('1468477306914930698', '2c93d0815fd312d3015fd318c55a0001', '1468477283707846657'), ('1468477306914930699', '2c93d0815fd312d3015fd31d8ab10002', '1468477283707846657'), ('1468477306914930700', '2c93d0815fd312d3015fd3228bcc0003', '1468477283707846657'), ('1468477306914930701', '2c93d0815fd312d3015fd322c2df0004', '1468477283707846657'), ('1468477306914930702', '2c93d0815fd312d3015fd323341c0005', '1468477283707846657'), ('1468477306914930703', '2c93d0815fd312d3015fd32d2bf50006', '1468477283707846657'), ('1468477306914930704', '2c93d0815fd312d3015fd32dbe1d0007', '1468477283707846657'), ('1468477306914930705', '2c93d0815fd312d3015fd32ded5b0008', '1468477283707846657'), ('1468477306914930706', '2c93d0815fd312d3015fd32e128a0009', '1468477283707846657'), ('1468477306914930707', '2c93d0815fd312d3015fd32e3fbb000a', '1468477283707846657'), ('1468477306914930708', '2c93d0815fd312d3015fd332d51c000b', '1468477283707846657'), ('1468477306914930709', '2c93d0815fd312d3015fd3330443000c', '1468477283707846657'), ('1468477306914930710', '2c93d0815fd312d3015fd33334e5000d', '1468477283707846657'), ('1468477306914930711', '2c93d0815fd312d3015fd3335c12000e', '1468477283707846657'), ('1468477306914930712', '2c93d0815fd312d3015fd33397f4000f', '1468477283707846657'), ('1470237986124734465', '2c93d0815fd2dff8015fd2e567140000', '1468162917871599618'), ('1470237986124734466', '2c93d0815fd2dff8015fd2e5d64a0001', '1468162917871599618'), ('1470237986124734467', '2c93d0815fd2dff8015fd2e6830c0002', '1468162917871599618'), ('1470237986133123074', '2c93d0815fd2e800015fd2e86ac10000', '1468162917871599618'), ('1470237986133123075', '2c93d0815fd2e800015fd2e8dbec0001', '1468162917871599618'), ('1470237986133123076', '2c93d0815fd2e800015fd2e9e5850002', '1468162917871599618'), ('1470237986133123077', '2c93d0815fd2e800015fd2ea2f730003', '1468162917871599618'), ('1470237986133123078', '2c93d0815fd2e800015fd2eac2ba0004', '1468162917871599618'), ('1470237986133123079', '2c93d0815fd312d3015fd3158d260000', '1468162917871599618'), ('1470372510556868610', '1465625043305373698', '1470369884750598145'), ('1470372510556868611', '1465625207164248066', '1470369884750598145'), ('1470372510556868612', '1466250736930287617', '1470369884750598145'), ('1470372510556868613', '1466250811962191874', '1470369884750598145'), ('1470372510556868614', '1466250937950695425', '1470369884750598145'), ('1470372510556868615', '1466251006531760130', '1470369884750598145'), ('1474041134387638274', '1465625043305373698', '1474041014040473602'), ('1474041134387638275', '1465625207164248066', '1474041014040473602'), ('1474041134387638276', '1466250811962191874', '1474041014040473602'), ('1474041134387638277', '1466250937950695425', '1474041014040473602'), ('1474041134387638278', '1466251006531760130', '1474041014040473602'), ('23cf0c0b872a4e8293fe916fe7816cb1', '2c93d0815fd312d3015fd32ded5b0008', '2c93d0815fd36205015fd36b83640000'), ('2d95ade4f4c14d5c932405a45796a384', 'ff8080815d4fc0e2015d4fd2f59e0001', '2c93d0815fd36205015fd36b83640000'), ('313d995443444eaa859d74ac78dfccee', 'ff8080815e6fecbf015e702a7afd0000', '2c93d0815fd36205015fd36b83640000'), ('3c445af404a54cfdae5b8c07c4bea810', '4028862b5d987476015d987949820000', '2c93d0815fd36205015fd36b83640000'), ('3f4d62ef6c37473d84f8134f66fe8aba', 'ff8080815e6fecbf015e703174990005', '2c93d0815fd36205015fd36b83640000'), ('4540f787a2994e13bb647e60587c69e8', 'ff8080815e703b3a015e703cad8b0002', '2c93d0815fd36205015fd36b83640000'), ('45aa666a958b49b4974b58f937cfac3a', '2c93d0815fd312d3015fd3228bcc0003', '2c93d0815fd36205015fd36b83640000'), ('552573d7a5534ca1820834c4cbe7f895', '2c93d0815fd2e800015fd2e86ac10000', '2c93d0815fd36205015fd36b83640000'), ('5d94ccd054c44a17847ebddc6137fc3d', '2c93d0815fd312d3015fd31d8ab10002', '2c93d0815fd36205015fd36b83640000'), ('5ea61e9bf9234027975158ac17c09a68', 'ff8080815d4e9212015d4e9796070004', '2c93d0815fd36205015fd36b83640000'), ('741fd40306dc46da98f0879d6f639c5b', 'ff8080815d4fd4d9015d4fd7d96b0002', '2c93d0815fd36205015fd36b83640000'), ('8328c472836b469c82322259711129fa', '2c93d0815fd2dff8015fd2e6830c0002', '2c93d0815fd36205015fd36b83640000'), ('842f76dd895e4bd389e8ef68e071d03d', '2c93d0815fd312d3015fd3330443000c', '2c93d0815fd36205015fd36b83640000'), ('89f5a41a6d7c4419b04fd9f0080ab04f', 'ff8080815e6fecbf015e702dabbd0004', '2c93d0815fd36205015fd36b83640000'), ('956cee5433914271a16d8fa30d1ad381', 'ff8080815e6fecbf015e702d84220003', '2c93d0815fd36205015fd36b83640000'), ('976e434e71ac4db89a38f1f844c2a8b7', '2c93d0815fd2e800015fd2e8dbec0001', '2c93d0815fd36205015fd36b83640000'), ('a11805819b3b43adb725d7133d0ec8a0', 'ff8080815e703b3a015e703c3d310000', '2c93d0815fd36205015fd36b83640000'), ('a177b5c9da324b9b9dfdfd1a84ef1ac8', '2c93d0815fd2e800015fd2e9e5850002', '2c93d0815fd36205015fd36b83640000'), ('a55f4d345d03488b8aa4e9e5535abccd', '2c93d0815fd2dff8015fd2e567140000', '2c93d0815fd36205015fd36b83640000'), ('b0c0b15b708349828821c3d3402d79a7', 'ff8080815e703b3a015e703cf71b0003', '2c93d0815fd36205015fd36b83640000'), ('b42c72f57f3942acbf5849644d7c798f', 'ff8080815d4fc0e2015d4fd29cf00000', '2c93d0815fd36205015fd36b83640000'), ('b5d83bff79be4ed4a8c139d5949f8ff0', 'ff8080815d4fd4d9015d4fd919fd0004', '2c93d0815fd36205015fd36b83640000'), ('bc14208911984e2488057618eec75cc4', '2c93d0815fd2e800015fd2eac2ba0004', '2c93d0815fd36205015fd36b83640000'), ('be765f349f984e7e8b7c58dc2a6524bb', 'ff8080815e6fecbf015e702d3e080002', '2c93d0815fd36205015fd36b83640000'), ('c1f5c61affc54582862f04c5224ce527', 'ff8080815e703b3a015e703c823b0001', '2c93d0815fd36205015fd36b83640000'), ('dd588c8ef54c46138f827871ca827bb2', '2c93d0815fd2dff8015fd2e5d64a0001', '2c93d0815fd36205015fd36b83640000'), ('e5d1eb1a18a94a75afa9140216ec6540', 'ff8080815e6fecbf015e702ac7790001', '2c93d0815fd36205015fd36b83640000'), ('f1d05d99294b47dfb6e8ce06426700d8', '2c93d0815fd312d3015fd3158d260000', '2c93d0815fd36205015fd36b83640000'), ('fdcc80d333c94ac3b0135a5ab3b43863', 'ff8080815d4fd4d9015d4fd9931d0005', '2c93d0815fd36205015fd36b83640000'), ('ffb41a81826545c38689b83d00887c7a', 'ff8080815d4e9212015d4e9714cd0003', '2c93d0815fd36205015fd36b83640000');
COMMIT;

-- ----------------------------
-- Table structure for t_update_application
-- ----------------------------
DROP TABLE IF EXISTS `t_update_application`;
CREATE TABLE `t_update_application`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `applicant` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '变更人',
  `applicate_time` datetime(0) NOT NULL COMMENT '变更时间',
  `back_information` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '驳回信息',
  `project_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目信息',
  `project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '项目名称',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '变更状态',
  `update_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '变更说明',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_update_application
-- ----------------------------
BEGIN;
INSERT INTO `t_update_application` VALUES ('1470248201339613185', 'admin', '2021-12-13 12:25:07', NULL, '1465543384337903618', '实习动员大会', '申报中', '111'), ('1470290037926182913', 'admin', '2021-12-13 16:17:31', '不得行', '1470289968141352962', '2', '申报失败', '222'), ('1472826831164772353', '111', '2021-12-20 15:10:55', NULL, '4028fb9f7d6b23a3017d6b2b33bc0014', '每日一讲', '申报中', NULL), ('1474049151166427137', '111', '2021-12-24 00:07:59', NULL, '1474043305174839298', '33', '申报成功', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
  `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '盐',
  `realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '真实姓名',
  `card` varchar(18) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '身份证',
  `sex` int(0) NULL DEFAULT NULL COMMENT '性别',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '电话号码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '邮箱',
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属学院',
  `birthday` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '生日',
  `nation` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '民族',
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '状态',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户类型（user是普通用户 admin 是超级管理员）',
  `administrative_position` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '行政职位',
  `specialization` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '研究专长',
  `administrative_function` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '管理功能',
  `professional_function` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '专业功能',
  `degree` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '学位',
  `resume` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '简历',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `UK_g8gqk4e142wekcb1t6d3v2mwx`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1464076877449682946', '111', 'ab2f893a590cc4f46a6dbfdbaf6b1f9d', '07a105772afb4d868edea5b2e4ee97a4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-26 11:41:43'), ('1468477055504154626', 'bbbbb', 'a1aee035252fc1f55775b4e43eddfc63', 'cf17ca1aaef24bdd99d8da5f83f73a1a', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-08 15:06:28'), ('1468477573710413825', 'ccccc', '7b30904ece0866cf84aefb79d47ba750', '8b3b665517104316aad156de19718402', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-08 15:08:31'), ('1468477660662530049', 'ddddd', '180fa0c8392681954c3dbacac7d92f82', '0eac039c616049ef948c7f46b8016345', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-08 15:08:52'), ('1471030131135893505', 'USER', '5c24e0135181b041efc4b99c02aaad64', '90cdd338b8df4ac5b7b3face3ea240e5', '王五', '511123200104141312', NULL, NULL, 'xiaokai198@qq.com', '四川省泸州职业技术学院', NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-15 16:11:28'), ('1485110581743632385', '1', 'c1186328c684dc61e114b0e6b9a5940c', '82c0e3aeff2b40f7a0a4bfa16c3c0cb3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-23 12:42:09'), ('2c93d0815fd34219015fd343ec860000', 'testuser', '4f09848b9c606b104814de833749eab6', '236f40c37a032d1661be9fc549d10131', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2017-11-19 15:52:44'), ('402896ca5f38db72015f38dc28640000', 'admin', 'e729b0114195e2e6e9a1a91e6b36f5ac', '737159ce79c4ce87142800b104511899', '彭凤凯', '511123200104141319', 1, '11111', '2019547086@qq.com', '泸州职业技术学院', NULL, NULL, '1', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, '2017-10-20 16:17:53'), ('4028fbbd7d2b8e26017d2bade94e0000', 'aaaaa', 'f4e399c63e81e5e7c81c74ed8d479d96', 'ad6b691069a3aeb1ecd14eff63fd9940', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'user', NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-17 10:15:58');
COMMIT;

-- ----------------------------
-- Table structure for t_user_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_user_permission`;
CREATE TABLE `t_user_permission`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `permission_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_user_permission
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主键',
  `role_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '角色id',
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES ('1464129102840737793', '40282a817d548d3d017d548d99df0000', '40282a817d57520d017d5752b8af0000'), ('1466251181639757825', '40282a817d50e7b7017d50ffe8740006', '402896ca5f38db72015f38dc28640000'), ('1468419878559043585', '1468162917871599618', '1464076877449682946'), ('1468476909848559618', '40282a817d548d3d017d548d99df0000', '4028fbbd7d2b8e26017d2bade94e0000'), ('1468477463458938882', '1468477192406237186', '1468477055504154626'), ('1468477627372339201', '1468477283707846657', '1468477573710413825'), ('1468477690966376449', '1468477381854560258', '1468477660662530049'), ('1471024811445698562', '40282a817d50e7b7017d50ffe8740006', '2c93d0815fd34219015fd343ec860000'), ('1474040857492271105', '1470369884750598145', '1474040739129012225');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
